My configuration is as follows.
I have a Linux MySQL server database on one box and
I want to connect to it from a local Windows XP laptop.
My application was developed using SunOneStudio.
I have registered the DSN and tested the database connection via ODBC
in Windows XP.
It apparently connects from XP to the server.
I have compiled two base classes and have a tester class which
compiles except for the following compiler error:
PathTesterOne.java [19:1] cannot resolve symbol
symbol : variable patholog
location: class PathTesterOne
Connection c = patholog.initialize();
"patholog" is the Database Name on the Linux MYSQL server.
the initialize method looks like this....
// establish the database connection
public static void initialize()
{
aMenu = new MainMenu();
try
{ // load the jdbc - odbc bridge driver for Windows
Class.forName("com.mysql.jdbc.Driver");
// The Data Source name is "patholog"
static String url = ("jdbc:mysql://192.168.1.101/test?user=jerald&password=wein3150");
static Connection aConnection;
static Statement aStatement;
Why am I not able to connect to the database?
I am not understanding what the source of the error may be.
I have a Master Package that executes a number a child packages.
In my SSIS Package Configuration:
1. I have an SSIS Configuation table that holds the connection string.
2. An XML Configuration File with a setting of configuration location stored in an enviornmental variable.
3. And finally, an Eveniornmental variable with the setting of ProjectFolderAbsolutePath value, where it is the full path of the project folder.
The project functions normally but everytime I open it I get the following error.
" Warning loading MasterPackage.dtsx: The configuration environment variable was not found. The environment variable was: "EnviorVariable". This occurs when a package specifies an environment variable for a configuration setting but it cannot be found. Check the configurations collection in the package and verify that the specified environment variable is available and valid."
I've got a package which reads a text file into a table and updates another. I set up configurations so that I could import it into the SSIS store on both my dev and live servers. Now, I'm getting this error. I tried removing the configs and am still getting it.
I've been through each step and everything looks okay. Does anyone have any idea (a) what's wrong, (b) how to localise the error or (c) get any additional information? Or do I just have to recreate the package from scratch?
Error at PartnerLinkFlatFileImporter: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found.
Error at PartnerLinkFlatFileImporter [Log provider "SSIS log provider for SQL Server"]: The connection manager "" is not found. A component failed to find the connection manager in the Connections collection.
My preferred programming language is Java (sorry Microsoft). I've searched for examples of running DMX queries into an Analysis Services database from Java but failed to locate any. I've seen suggestions that XMLA could be used but again, I can't locate any examples (in any language). For my current project I ran up the white flag and used C# instead but this wouldn't be an option in other cases. It would be possible to make the DMX calls from C# objects and call those from Java but that's pretty labourious to code.
Anyone have any tips for using Java against SQL Server? Our ITdirector is thinking of making us a Java shop, but I really would liketo stay with SQL Server as our RDBMS. We have Oracle Financials butour in-house development (currently VB6 client-server, soon to bereplaced by a service-oriented architecture based around Sonic andincluding SalesForce, both of which are Java) has been against SQLServer. He says five years ago at his old company Java/SQL Server hadlousy performance. I vaguely remember that since then Microsoft cameout with their own JDBC driver for SQL Server... Anyone have experiencewith this? Any performance tips will be hugely appreciated.TIA
hi all and sorry for my englishI write into a SqlServer2000 database via jdbc using a PreparedStatement(pstmt) and one of fields is a TimeStamp, my code is:qwdum=System.currentTimeMillis();pstmt.setTimestamp(8 , new Timestamp(qwdum));sometimes the field on table is correct (the milliseconds are the same oflast 3 digits of variable qwdum), other times it has a difference of 1 o 2millisecondsthe same code with jdbc Oracle or iSeries works fineany idea?thanksRoberto Nenni
I am in the process of evalulating using SSRS with our Java app and I have a couple questions up front:
I see you can call SSRS thru web services and display an HTML report. Can you have the report go straight to the printer, rather then preview. So we can offer both Print and Print Preview options.
I see the page streaming option. So on page preview we could ask for page 1 to get a snappy display, then ask for the rest of the report to generate in background?
i want to use the sql server with java, but i don't find any documentation. I already loaded the sqljdbc.jar from the microsoft webpage, but i don't know how to connect.
This is my Connection function, but it doesn't connect. I get an exception like "cannot connect to ..."
Hello. I have just got windows xp profesional x64.When i am on the internett my jave does not open the programs and games.Can some one help me please.Thanks.
Hello. I am having trouble finding a descent API for executing TSQLvia JDBC. I have tried the Microsoft driver AND the JDTS driver's butget the same syntax errors. I am hoping there is a good solution alsofor executing scripts using the same. Any help is MUCHappreciated.Thx.
I'm having a problem getting back appropriate metadata for storedprocedures from MS SQL Server 2000 and 2005.I've created a simple stored procedure that has an output param thatis a cursor.When I ask for the metadata for that stored procedure using a JDBCdriver I get back a datatype value for my parameter specifying an intnot a result set.Here is my stored procedure:CREATE PROCEDURE xasp_INx_OUTcur_RETint@OutCrsr CURSOR VARYING OUTPUT ASSET @OutCrsr = CURSOR FORSELECT LASTNAME, FIRSTNAMEFROM CONTACTS2OPEN @OutCrsrRETURN 7Here is the java code:Connection conn = driver.connect(url, props);DatabaseMetaData dbMeta = conn.getMetaData();ResultSet columnRes = dbMeta.getProcedureColumns(cat, schem, name,"%");while (columnRes.next()){String procCat = columnRes.getString("PROCEDURE_CAT");String procSchem = columnRes.getString("PROCEDURE_SCHEM");String procName = columnRes.getString("PROCEDURE_NAME");String colName = columnRes.getString("COLUMN_NAME");short colType = columnRes.getShort("COLUMN_TYPE");short dataType = columnRes.getShort("DATA_TYPE");String typeName = columnRes.getString("TYPE_NAME");int precision = columnRes.getInt("PRECISION");// pass this info on to another method}The dataType is set to the type returned from the procedure not to thetype for the param.Am I doing something stupid here? Did I create my stored procedurewrong?Any help would be appreciated.Thanks.Jon
have a Java Class that I want to be able to access from within a SQL Server Stored procedure. I know we can access C# and other .NET Framework code, but how can you access a Java Class?
I want to call a stored procedure (SQL SErver 2000) from JAVA. The SP contains a temporary Table. At the end of the SP there is a Select like "Select * from #tmp".
Now I get no Resultset in my JAVA - Application. When i do a normal Select on an Table I get a Resultset.
I need the temp. Table in this SP. How can I get the Result in JAVA. It is urgent for me.
Hi.. We have a java application which connect to our MS-SQL DB during midnight using JDBC connector and extract information. But very often ,the java applicatian halted and because of the deadlock as shown below.
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Transaction (Process ID 54) was deadlocked o n lock resources with another process and has been chosen as the deadlock victim.
now the java programmer is blaming me that the MS SQL DB is having deadlock and cause their Java application to hang.
Is there any way to clear the deadlock before the the Java applcation run or how to prove the Java application script itself is having problem and causing the deadlock ?
I am working on a hospital application using java programming language, i need to know how to connect two applications to one table over a network where the data read by application one can not be read by application 2 and vise versa...
I have a java compiled jar file, which accept the connection string as follows: -Uusername -Ppassword -Sservername:port
This string works fine with the default instance of SQL Server, I mean as long as you supply the name of the SQL Server as 'SQLServer', but if I want to run it against the named instance of SQL Server like 'SQLSERVERNamedInstance' then the connection is failing, giving me the unknown host error. Any idea why?
Hello,Does anyone know if SQL Server supports invoking Java methods from aStored Procedure or even a Trigger. For example, it looks like oracleprovides this capability based on the article athttp://www.cs.umbc.edu/help/oracle8...86/04_call2.htm. Itlooks like for a Trigger it uses a SP as an in-between. Any insightinto this would be greatly appreciated.Thanks,--Willard
I am facing a lot of problems integrating the reporting services into the java application using url access.If any body has sucessfully implemented this please provide me with the code or point me to the resources.
Hi, Is there a special jdbc driver for SQL Server Compact Edition (2005) available? I'm getting error messages when trying to run java application on Pocket PC (Mobile 5.0):
java.lang.UnsatisfiedLinkError: java/sql/DriverManager.getCallerClassLoader()Ljava/lang/ClassLoader; at java.sql.DriverManager.getConnection(Unknown Source)...
I have a Java Class that I want to be able to access from within a SQL Server Stored procedure. I know you can access C# and other .Net code, but can you also access a regular Java class this way?
i just downloaded the latest version of the drver v 1.2 am using Eclipse latest version along with Microsoft SQL Server 2005 with Express Mangment Tools i installed the driver (copied the .dll to C:windowssystem32 ad included the .jar file in my project) am using mixed mode authentication
when i use the following url: "jdbcqlserver://localhost:1433;user=sa;password=;integratedSecurity=true;"; it connects to the master DB... good
whe i use the following: "jdbcqlserver://localhost:1433;user=sa;password=;database=MyHits;integratedSecurity=true;"; it gives me the follwoing:
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "MyHits" requested by the login. The login failed. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at db_worker.<init>(db_worker.java:25) at runner.main(runner.java:10)
although am sure i didnt miss anything (enbaled tcp/ip, no special permission thing on the DB MyHits) etc..
note: the databaseName ield in the url only works when i set it = to master,else it wont work (northwind or whatever) wont work!!!
Is there a way to connect to mdf database files using java language?
I use the code below to connect to my oracle database... but now i want to use java code to connect to mdf database file...
Is there a way to do it? What will be the connection string in that case? Thanking you in advance..
/* THIS CODE Connects to oracle database using java language*/ Connection con = null; Statement st =null; Statement batchStm = null; System.setProperty("jdbc.drivers","sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("Registred Driver");
//Conecting to dbase con = DriverManager.getConnection("jdbcdbcbSourceOra","scott","tiger");
Anyone have any experience with running MS SQL Server web applications using Java servlets with connection pooling? Any settings/tricks/traps that we should be aware of?
Our basic problem is that under CERTAIN senarios (which we haven`t been able to strictly identify yet), it appears that each browser client has to wait for the last client to finish - only shared locks are being applied to the database.