tag:blogger.com,1999:blog-37621059.post8919268067615283516..comments2018-12-08T14:44:58.481-08:00Comments on Kris' blog: Getting started with an ExtensionAnonymoushttp://www.blogger.com/profile/01592459412450086148noreply@blogger.comBlogger27125tag:blogger.com,1999:blog-37621059.post-72583114188983370532010-08-19T12:56:08.570-07:002010-08-19T12:56:08.570-07:00I need to update the skeleton to the latest will p...I need to update the skeleton to the latest will probably do it when 3.0 comes out. Let me know if you hit any other issues.Anonymoushttps://www.blogger.com/profile/01592459412450086148noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-16583783681933674252010-08-19T12:39:50.140-07:002010-08-19T12:39:50.140-07:00Never mind Kris. I used the newscriptrunner and so...Never mind Kris. I used the newscriptrunner and so far i havent had any issues. Will let you know if i run into any other problems.<br /><br />Thanks,<br />KarthikKarthikhttps://www.blogger.com/profile/13284720148286763320noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-87977634451071568982010-08-19T09:32:09.922-07:002010-08-19T09:32:09.922-07:00Hi Kris,
I am trying to write a java plugin which ...Hi Kris,<br />I am trying to write a java plugin which would help me generate the ddl statement , with comments and i am also planning to add some additional features like generating a change script if a few columns were added.<br /><br />I prefer not to do this in XML as java is much more flexible when it comes to writing out to a file.<br /><br />I am trying to build this sample code. But i Karthikhttps://www.blogger.com/profile/13284720148286763320noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-38571956350528328262008-01-10T14:11:00.000-08:002008-01-10T14:11:00.000-08:00It's very odd if you get an ora-00900 invalid stat...It's very odd if you get an ora-00900 invalid statement from this:<BR/>select object_name from user_objects<BR/><BR/>Have you tried running that sql directly in the worksheet or sqlplus?<BR/><BR/>The "Data" tab does no use the method described in the blog about adding datatype support. I should have mentioned that works only with the read-only grid of data.Anonymoushttps://www.blogger.com/profile/01592459412450086148noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-82069598827840721372007-12-12T05:12:00.000-08:002007-12-12T05:12:00.000-08:00Hello,I have tried the skeleton in SQLDeveloper 1....Hello,<BR/><BR/>I have tried the skeleton in SQLDeveloper 1.2.1<BR/><BR/>For the "ls", it returns an error ORA-00900 Invalid SQL statement.<BR/><BR/>For the reconnect, it says in the status bar "Reconnected", but how can I be sure?<BR/><BR/>And a final question, and here I am referring to another of your blogs - New datatype support (http://krisrice.blogspot.com/2006/08/sursanhttps://www.blogger.com/profile/10146551624440967955noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-79788974962169259972007-12-06T09:04:00.000-08:002007-12-06T09:04:00.000-08:00You'll find the build.xml in the etc directory.You'll find the build.xml in the etc directory.Anonymoushttps://www.blogger.com/profile/01592459412450086148noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-60700189499420358222007-11-21T03:42:00.000-08:002007-11-21T03:42:00.000-08:00Hi Kris,Step 3: Run ant deployI can't find a build...Hi Kris,<BR/><BR/>Step 3: Run ant deploy<BR/><BR/>I can't find a build.xml in the skeleton folder. Do i need to deploy it without one ?<BR/><BR/>thanks,<BR/>JochenAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-37621059.post-25278134563122735042007-06-13T06:00:00.000-07:002007-06-13T06:00:00.000-07:00Hi Kris,I want to go via the ODBC data source name...Hi Kris,<BR/><BR/>I want to go via the ODBC data source name to be able to connect to a non-oracle database. How will I able to do that in SQL Developer ? And if incase this needs an SQL Developer extension using JDeveloper. Please help me with any pointers on how to proceed.<BR/><BR/>Thanks you very much for your very valuable assistance.<BR/><BR/>WajahathAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-37621059.post-62889775944412641002007-04-27T15:55:00.000-07:002007-04-27T15:55:00.000-07:00Right now I have the new menu on the Right click o...Right now I have the new menu on the Right click of a connection. Similar to the"Reconnect" in the Skeleton example.<BR/><BR/>I would like to have it in the main toolbar as well but did not know how to proceed. Will having it on the main toolbar help in displaying the results in the script output window instead of the log pane ?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-37621059.post-20138545264090439242007-04-27T15:20:00.000-07:002007-04-27T15:20:00.000-07:00There's no real easy way to do that from a menu. A...There's no real easy way to do that from a menu. Are you adding a menu inside the worksheet or to the main toolbar ?Anonymoushttps://www.blogger.com/profile/01592459412450086148noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-62129230618937963942007-04-27T14:51:00.000-07:002007-04-27T14:51:00.000-07:00THanks a lot Kris. That did take care of the probl...THanks a lot Kris. That did take care of the problem. Now one last but remains, Can I have the output to appear in the script output window instead of the log pane.<BR/> <BR/>This way I would be 100% complete.<BR/><BR/>Thanks again<BR/>WajAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-37621059.post-56348919648185791052007-04-27T14:17:00.000-07:002007-04-27T14:17:00.000-07:00You have a signature mis-match. The ScriptUtil ta...You have a signature mis-match. The ScriptUtil takes in <BR/>First) an inputstream of what's to run<BR/>Second) a string which is the name of the connection.<BR/><BR/>So the code would look something like this:<BR/><BR/> String sql = "select 1 from dual";<BR/> StringBufferInputStream in = new StringBufferInputStream(sql);<BR/><BR/> ScriptUtils.runAsScript(in, getDBObject(Anonymoushttps://www.blogger.com/profile/01592459412450086148noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-59278852971889569092007-04-26T16:32:00.000-07:002007-04-26T16:32:00.000-07:00Thanks Kris,I get the following error when I try t...Thanks Kris,<BR/>I get the following error when I try to use the oracle.dbtools.raptor.scriptrunner.utils.ScriptUtils.runAsScript method.<BR/><BR/>cannot find symbol<BR/> [javac] symbol : method runAsScript(java.io.FileInputStream,java.sql.Connection)<BR/> [javac] location: class oracle.dbtools.raptor.scriptrunner.utils.ScriptUtils<BR/> [javac] Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-37621059.post-90778076672640100512007-04-26T14:47:00.000-07:002007-04-26T14:47:00.000-07:00If your just trying to run a script, here's the ea...If your just trying to run a script, here's the easiest way to do it.<BR/><BR/>oracle.dbtools.raptor.scriptrunner.utils.ScriptUtils.runAsScript(inStream, connName);<BR/><BR/>and the connName can be gotten from :<BR/>dbObject.getConnectionName()<BR/><BR/>This will run the inputstream as a script and the output will goto the log pane.Anonymoushttps://www.blogger.com/profile/01592459412450086148noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-4015001681212414992007-04-26T14:21:00.000-07:002007-04-26T14:21:00.000-07:00Thanks for your response. Sorry about not making m...Thanks for your response. Sorry about not making myself clear. Let me explain the latest status of my problem. I am trying to execute a query directly from a new dropdown menu click item (for eg Reconnect) without interacting with the user interface text entry and execute with. <BR/><BR/>Using your Skelton example as reference, Is there a way to capture a reference to the ScriptRunnerContext Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-37621059.post-31409412093301293692007-04-26T10:48:00.000-07:002007-04-26T10:48:00.000-07:00I'm not sure I follow your question. If you looks ...I'm not sure I follow your question. If you looks at the reconnect, it's in java and shows how to get the actual sql connection. Then from that you can do anything. <BR/><BR/>-krisAnonymoushttps://www.blogger.com/profile/01592459412450086148noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-55007137797874259542007-04-23T21:29:00.000-07:002007-04-23T21:29:00.000-07:00Thanks Kris Rice. Your example was very helpful. I...Thanks Kris Rice. <BR/>Your example was very helpful. I had a similar requirement where I need to extend OWBM to enable The following<BR/>1.Create a new menu item (say "Create Tables")<BR/><BR/>2. When the user clicks on "Create Tables", the right hand screen should populate the all the create table scripts for tables in that Oracle connection. ( Much like the subset of what Generate would Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-37621059.post-88941159960145833122007-04-23T21:14:00.000-07:002007-04-23T21:14:00.000-07:00Thanks Kris Rice.I was able to create a new custom...Thanks Kris Rice.<BR/>I was able to create a new custom menu item "Create tables" on the drop down on an oracle connection (like Reconnect).<BR/><BR/>Now I have a requirement where in, I need to be able to generate the create table script for all the tables in the Oracle connection. (only create tables). The script I need is much like a subset of Generate the "Converted Models". <BR/>The new Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-37621059.post-20682591436882833932007-04-06T13:40:00.000-07:002007-04-06T13:40:00.000-07:00This should work on any platform. What issues are...This should work on any platform. What issues are you seeing?<BR/><BR/>-krisAnonymoushttps://www.blogger.com/profile/01592459412450086148noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-34948023801530194672007-04-06T13:03:00.000-07:002007-04-06T13:03:00.000-07:00Any chance of this working on SQL Developer for Wi...Any chance of this working on SQL Developer for Windows?<BR/><BR/>Steps on how to do that (for a noob)?<BR/><BR/>Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-37621059.post-32145636683191243452007-03-01T00:06:00.000-08:002007-03-01T00:06:00.000-08:00Thanks a lot Kris, the .jws and .jpr did the trick...Thanks a lot Kris, the .jws and .jpr did the trick, and got the new extension up & running...<BR/><BR/>K.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-37621059.post-18492539649541151572007-02-28T14:39:00.000-08:002007-02-28T14:39:00.000-08:00Take a look here : http://esdev.svn.sourceforge.ne...Take a look here : http://esdev.svn.sourceforge.net/viewvc/esdev/trunk/org.esdev/skeleton/<BR/><BR/>I just made a jdev application ( the .jws ) and a jdev project ( the .jpr ) <BR/><BR/>Those should get you going. The project is looking at ../sqldeveloper as the location of sqldev to add all the libraries to the classpath.<BR/><BR/>-krisAnonymoushttps://www.blogger.com/profile/01592459412450086148noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-36325056315079426312007-02-27T03:36:00.000-08:002007-02-27T03:36:00.000-08:00Hi Kris,I'd love to get going with this, but don't...Hi Kris,<BR/><BR/>I'd love to get going with this, but don't know how to set it up under JDeveloper. It's unlike the extension examples Sue talked about, and the source doesn't even recognize oracle.dbtools.<BR/>Any hints?<BR/><BR/>Thanks,<BR/>K.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-37621059.post-69798063218033900042007-02-20T22:09:00.000-08:002007-02-20T22:09:00.000-08:00I just looked at the sources and there's currently...I just looked at the sources and there's currently no way to hook into the Execute F9. I'll see if we can get it added for the next version.<BR/><BR/>-krisAnonymoushttps://www.blogger.com/profile/01592459412450086148noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-45996809704419636082007-02-20T08:24:00.000-08:002007-02-20T08:24:00.000-08:00Excellent post! It has inspired me to write an ext...Excellent post! It has inspired me to write an extension. Is there a similar way to get the functionality of beginScript and endScript for the Execute command (F5)? If not what would be the best option of inserting SQL before and after an execute.Unknownhttps://www.blogger.com/profile/17789001829484161541noreply@blogger.com