Re: MS SQL Server2000 EOModel Connection Problem
Re: MS SQL Server2000 EOModel Connection Problem
- Subject: Re: MS SQL Server2000 EOModel Connection Problem
- From: "Jonathan Fleming" <email@hidden>
- Date: Tue, 27 May 2003 17:18:26 +0100
From: "brianmac@baseview" <email@hidden>
To: "email@hidden" <email@hidden>
Subject: Re: MS SQL Server2000 EOModel Connection Problem
Date: Tue, 27 May 2003 11:08:09 -0400
Jonathan,
I still don't think the issues you are reporting are related to EOModeler.
I
ran into same exact issues with JDBC connection from my own java swing app.
The only default user connection I could connect to Northwind was:
jdbc.microsoft.sqlserver://10.1.1.254/DatabaseName=Northwind;User=sa;Passwor
d=sa
I've got past this bit happily, however, Brian,
I have now managed to developed another problem which again is seemingly to
do with
EOModeller not working properly:
having used the connection below as set out in EOModeller dialog box,
USER=sa
PASSWORD=xxxxxxxx
URL=jdbc:microsoft:sqlserver://192.168.0.4\\DEVBOXSQLSERVER:1433;DatabaseNam
e=JandM;SelectMethod=cursor
DRIVER=Empty
PLUGIN=Empty
I no longer get an error message such as these:
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
but when I go to to the Menu, Property > Generate SQL I get
com.Microsoft..jdbc.sqlserver.SQLServerDriver come up in a dialog box with
an OK button, I click OK and all seems well still. No errors reported.
I then click the Tables button in the Generate SQL Dialog box and I can see
these tables: dbo.dtproperties, dbo.sysconstraints, dbo.syssegments,
however, when i click Execute SQL to create a table with primary and foriegn
key constraints, I get the error message below:
An unexpected error has occurred which may cause EOModeler to malfunction.
You may want to save copies of your open documents and quit EOModeler.
Error: java/lang/IllegalArgumentException:
com.Microsoft..jdbc.sqlserver.SQLServerDriver
Stack Trace:
java.lang.IllegalArgumentException:
com.Microsoft..jdbc.sqlserver.SQLServerDriver
at JDBCContext.connect(Compiled Code)
at JDBCContext._tryConnect(JDBCContext.java:246)
at JDBCContext._fetchJDBCInfo(Compiled Code)
at JDBCPlugIn.jdbcInfo(JDBCPlugIn.java:848)
at MicrosoftPlugIn.jdbcInfo(MicrosoftPlugIn.java:66)
at JDBCAdaptor.jdbcInfo(JDBCAdaptor.java:228)
at JDBCExpressionFactory.createExpression(JDBCExpressionFactory.java:22)
at
EOSQLExpressionFactory.expressionForEntity(EOSQLExpressionFactory.java:67)
at
EOSynchronizationFactory._expressionForEntity(EOSynchronizationFactory.java:
984)
at EOSynchronizationFactory.createTableStatementsForEntityGroup(Compiled
Code)
at EOSynchronizationFactory.createTableStatementsForEntityGroups(Compiled
Code)
at EOSynchronizationFactory.schemaCreationStatementsForEntities(Compiled
Code)
at EOSynchronizationFactory.schemaCreationScriptForEntities(Compiled Code)
And since this I have set the three .jar files that are supplied for MS SQL
Server 2000 driver in the
Apple\Library\Java directory
msbase.jar
msutil.jar
mssqlserver.jar
So the javaConfig.plist looks like like this:
{
Vendor = sun;
sun = {
VM = "$NEXT_ROOT/Library/JDK/bin/java.exe";
DefaultClasspath =
"$HOME/Library/Java;$NEXT_ROOT/Local/Library/Java;$NEXT_ROOT/Library/Java;$NEXT_ROOT/Library/JDK/lib/classes.zip;$NEXT_ROOT/Library/Frameworks/JavaVM.framework/Classes/awt.jar;$NEXT_ROOT/Library/JDK/lib/swingall.jar";$NEXT_ROOT\Library\Java\msbase.jar;$NEXT_ROOT\Library\Java\msutil.jar;$NEXT_ROOT\Library\Java\mssqlserver.jar;
DefaultBeanpath =
"$HOME/Library/JavaBeans;$NEXT_ROOT/Local/Library/JavaBeans;$NEXT_ROOT/Libra
ry/JavaBeans";
Compiler = "$NEXT_ROOT/Library/JDK/bin/javac.exe";
Headers = "$NEXT_ROOT/Library/JDK/include
$NEXT_ROOT/Library/JDK/include/winnt";
Library = "$NEXT_ROOT/Library/JDK/lib/javai.lib";
DebugLibrary = "$NEXT_ROOT/Library/JDK/lib/javai_g.lib";
};
}
However, since restarting the machine I get these errors now:
If I go to Set Adaptor Info... in the Model menu, it's greyed out. I also
now get the error below if I try to use Switch Adaptor in the Model Menu and
Generate SQL in the property menu is greyed out too:
Error Message:
Unable to load the JDBC adaptor: classForAdaptorNamed:: Unable to load the
bundle for the adaptor named JDBC. The possible causes for this error are:
the adaptor executable cannot be dynamically linked into your application,
you are on PDO and have not linked the adaptor into your application, or the
adaptor executable is not present on your host.
Is the classpath set correctly? or is this something esle?
Is anyone using WO5.2.1 on a Window 2000 platform connecting a MS SQL Server
2000 (Developer Edition) using the standard JDBC supplied by Microsoft with
WO5.2.1 and able to create their database tables etc using EOModeller?
If so how did you get this thing working?
For this driver Microsoft say:
The following versions of SQL Server will be supported for use with the SQL
Server 2000 Driver for JDBC SP1:
SQL Server 2000 with Service Pack 1 or higher
The SQL Server 2000 Driver for JDBC is supported on the following operating
systems:
Microsoft Windows. XP
Microsoft Windows 2000 with Service Pack 2 or higher
AIX
HP-UX
Solaris
Linux
The following versions of the JDK will be supported for use with the SQL
Server 2000 Driver for JDBC:
JDK 1.1.8
JDK 1.2
JDK 1.3
Jonathan :^/
Feel free to contact me offlist if you are still having trouble.
Enjoy,
Brian
=================================
Brian McDerment
email@hidden
Asst. Circulation Product Manager
Harris & Baseview
http://www.baseview.com
http://www.jazbox.com
_________________________________________________________________
Find a cheaper internet access deal - choose one to suit you.
http://www.msn.co.uk/internetaccess
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.