This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 77463 - Incoretc DataSource object for (some?) JDBC drivers
Summary: Incoretc DataSource object for (some?) JDBC drivers
Status: RESOLVED DUPLICATE of bug 76686
Alias: None
Product: serverplugins
Classification: Unclassified
Component: Sun Appserver 9 (show other bugs)
Version: 5.x
Hardware: All All
: P3 blocker (vote)
Assignee: Nitya Doraisamy
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-06-06 20:18 UTC by jernejk
Modified: 2006-06-27 07:58 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description jernejk 2006-06-06 20:18:53 UTC
When using jtds, Microsoft JDBC driver or JDBC-ODBC bridge to use MS SQL server
with Persistence API, the following error occurs 

RAR5111 : Error casting to javax.sql.Datasource :{0}

RAR5114 : Error allocating connection : [Error in allocating a connection.
Cause: com.microsoft.sqlserver.jdbc.SQLServerDriver]

Workaround (provided by Andrei Badea):
- undeploy the application from the server
- in the admin console (http://localhost:4848) make sure the connection
pool and the data source you created have been removed (remove them if
necessary).
- under the Server Resources node in the Project view open the
connection pool properties (right-click and Properties). Enter
"net.sourceforge.jtds.jdbcx.JtdsDataSource" in the DataSource Classname
field. Then open the Properties list (last item) and add the following
properties: serverName, portNumber and databaseName (their meaning
should be clear). Leave the other three properties there.

Expected fix: use appropriate DataSet classes for JDBC drivers
Comment 1 Petr Blaha 2006-06-06 20:32:24 UTC
This Sun Resource issue. Move to correct component.
Comment 2 Nitya Doraisamy 2006-06-27 07:58:52 UTC
Caused by same issue as 76686. Fix is common for both.
Netbeans uses database's driver-classname while appserver uses the
datasource-classname. There is a mismatch happening in the mapping.

*** This issue has been marked as a duplicate of 76686 ***