[Dbix-class] why the connection to database failed on the first time, success after refresh

Hugh Wang yowang at verizon.net
Thu Jun 6 05:38:09 GMT 2013


I am trying to use Catalyst, with DBIx::Class to connect to a MS
Sqlserver database.
after  I start the Catalyst server,
perl script/libApp_server.pl -r

I connect to a page to open a table and display it,
but the first time when I open the page,
such as:   http://localhost:3000/admin/ticket

it shows error:

[error] DBIx::Class::Storage::DBI::_do_query(): DBI Exception:
DBD::ODBC::db do
failed: [Microsoft][ODBC SQL Server Driver][SQL Server]'=' Grammer Error
nearby (SQL
-42000)(DBD: Execute immediate failed err=-1) at
K:\LibApp\lib/LibApp/Controller
/admin.pm line 47

but after I refresh to reload the page, it works good .  
if I restart the server, the error will show up again for the first time
I open the same web page.
the refresh of the same page, will work good.

what's wrong with it?  any one has experience

thanks

Hugh Wang



More information about the DBIx-Class mailing list